package com.javasm.finance.dao;

import com.javasm.finance.entity.Prod;
import com.javasm.finance.entity.ProductCategory;
import com.javasm.finance.entity.User;

import java.sql.SQLException;
import java.util.List;

public interface ProdDao2 {
    List<Prod> queryProd(Integer page,Integer pageSize,String prodName,String prodCategoryName, String managerName,Integer prodState) throws SQLException;
    long findTotalNum(String prodName,String prodCategoryName,String managerName,Integer prodState) throws SQLException;
    List<ProductCategory> querySeries() throws SQLException;
    List<User> queryManager(String userName) throws SQLException;
    int addProd(Prod prod) throws SQLException;
    int deleteProd(Integer prodId) throws SQLException;
    Prod findByPid(Integer prodId) throws SQLException;
    int editProd(Prod prod) throws SQLException;
    Prod findByPidRemi(Integer prodId) throws SQLException;
    int addRemi(Prod prod) throws SQLException;
}
